Exploring Microsoft Excel’s Hidden Treasures by David Ringstrom CPA

Author:David Ringstrom, CPA
Language: eng
Format: epub
Publisher: Packt Publishing Pvt Ltd
Published: 2022-08-30T00:00:00+00:00

Figure 7.16 – Cells G4:G5 remain unchanged

Now, let’s take structured references a step further by showing how to write formulas that reference data on another worksheet without switching worksheet tabs.

Using structured references to write formulas

The Feature Comparison worksheet contains a Table Named Bridges that we’ll reference in our next example by writing a formula in segments without needing to switch between worksheets:

Type =COUNTIF(Bridges[ into cell V4 of the Formula References worksheet.

Tap the down arrow three times to choose Type of Bridge, as shown in Figure 7.17, and then press the Tab key to add the field name to your formula. Then, type in ] to close the field name:

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.